Configuring general setup options

The General Setup driver controls various system-wide settings that apply to Threshold and Non-Threshold templates.

To configure general setup options:

  1. From the Configuration tab, click General Setup.

  2. Complete the fields in the following areas, as needed:

    System-Wide Parameters

    Option Description
    Discount Rate for NPV Type the hurdle rate used to calculate Net Present Value.
    Sales Tax Rate Type the sales tax rate to use when purchasing capital items.
    Capital Expenditure Cash Flows If your organization pays sales tax, select an option to control the discounting methodology for the capital expenditure cash flows in the NPV calculation.
    Use Leap Year Calculations? Click the toggle to use (Yes) or not use (No) leap year calculations.
    Default GL Account Select the default General Ledger account.
    Change Useful Life? Click the toggle to allow (Yes) or not allow (No) users to change the Useful Life field.

    Summary and Pro Forma Financial Setup

    Option Description
    Depreciation Default - Pro Forma Fin Inputs Select the default depreciation to use in the pro forma template.
    Depreciation Default - Summary Fin Inputs Select the default depreciation to use in the Summary template.
    Enable Funding Sources - Pro Forma Fin Inputs Click the toggle to allow (Yes) or not allow (No) users to add additional funding sources beyond the default source of Routine Capital on the NonThreshold template.
    Enable Funding Sources - Summary Fin Inputs Click the toggle to allow (Yes) or not allow (No) users to add additional funding sources beyond the default sources of Routine Capital and Unrestricted Donations on the Threshold template.
    Use BalSheet worksheet for Pro Forma? Click the toggle to include (Yes) or not include (No) the BalSheet worksheet in the pro forma plan files.
    Proforma Change Number of Years Click the toggle to enable (Yes) or disable (No) users from changing the number of years in the pro forma plan files.
    Proforma Default Number of Years Select the default number of years to display in the pro forma plan files.

    Project Analysis Thresholds

    IMPORTANT: Make sure to reference the correct template in the following options.

    Option Description
    Threshold Analysis-Capital
    1. Type a capital dollar amount for determining which projects require pro forma templates.
    2. Type the error message to display if the user attempts to use a Summary template.
    Threshold Analysis-Revenue
    1. Type a revenue dollar amount for determining which projects require pro forma templates.
    2. Type the message to display if the user attempts to use a Summary template.
    NonThreshold Analysis

    1. Type a minimum capital dollar amount for projects to include in the capital budget.

    2. Type the error message to display if the user enters a project below the minimum.

    Template Input Field Names

    1. Type a name for the field type.

    2. In the Required for Save? column, click the button to require (Yes) or not require (No) the user to save the information.

    IMPORTANT: If the user does not enter this data, the workbook will save with errors. As a result, the project workbook cannot be activated in the process flow.

    Summary Links

    By default, users can access the Executive Summary report directly from the plan file. However, you can modify this link by designating another report - including any custom reports used by your organization - and changing the link name, if desired.

    Click image to view full size

    Option Description
    Enter Link Document Path Enter the path and file name where the report resides in the system. For example, \Axiom\Reports Library\Capital Planning Reports\Project Reporting - Web\Executive Summary.xlsx
    Enter Display for Link

    Enter a friendly name for the link. The name used by default is Executive Summary.

    TIP: The name should be short so that it does not take up too much space in the user interface.
    Form Enabled?
    • To launch the report as web-enabled, click the toggle to Yes.
    • To launch the report as an Excel report, click the toggle to No.

    Code to Account Conversion for Capital Tracking Transfer

    To configure the codes, see Updating the CODE dimension.

    1. In the Account column, select the general ledger account in Axiom Capital Tracking in which to map to the Axiom Capital Planning code.
    2. In the Exclude from NPV Selection column, click the button to include (Yes) or exclude (No) the code from the Net Present Value (NPV) financial metric.
  3. After making your changes, in the upper right corner of the page, click the disk icon to save your changes.
  4. At the confirmation prompt, click OK.

If you are making changes to this driver, make sure to process the plan files to propagate your changes.